SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498104 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498104 [ RunTime:0.002358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253132,185521,492613,960703,617578,238027,218035,737410,594019,779397,70891,398637,279103,300311,768498,290636,939758,441641,179827,478312,291257,183912,69305,958523,78404,142448,375297,858,685441,1026415,416196,117782,878620,258242,813908,66591,871199,202227,961848,1005980,651858,992778,771263,771200,927065,791363,113521,486538,517466,463809,860187,900934,836082,42948,300564,290262,388058,264244,725445,924606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]