SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413631 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413631 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34947,807059,444564,962431,561104,452678,978661,464226,334645,13083,411257,87090,221802,32567,282954,212910,414861,569195,434782,378005,272513,39145,553108,388520,415757,616570,818747,106327,100532,429851,106181,602402,22077,694909,787801,41699,257900,726475,267370,417509,83890,897329,603652,1024538,639649,818166,924869,316031,250889,652812,344605,283047,68348,47009,904257,383795,866415,847805,545344,910367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]