SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 64201 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 64201 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155358,474454,365883,411290,517688,562992,763683,541441,298206,27965,753450,801747,643875,7715,41675,371635,415765,59191,514930,1020356,826231,869067,618808,760032,749887,45983,413564,907161,722218,19318,446696,1029642,876112,554393,187374,645112,899898,833406,280452,946011,664580,637672,353055,1021046,125749,901241,720740,750335,189751,155401,535851,222583,292837,583544,154037,717106,232338,14902,504844,903733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 64201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 64201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]