SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497543 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497543 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946360,427448,742151,1026386,491606,404307,933754,546570,295089,243322,421955,958138,55573,143650,527660,106421,64832,865091,734242,290251,234160,614373,904372,41272,510339,40749,848553,542356,619424,234825,967412,91004,428022,374810,987206,620475,887430,605329,250428,265198,200297,921757,961489,359938,541940,509639,73733,618918,753566,834161,771166,953636,399459,772907,301433,622570,876629,775195,563734,793505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]