SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414416 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414416 [ RunTime:0.002988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65509,82883,413605,163531,336937,829801,408260,484812,170836,255156,376169,574511,332971,814613,66941,666015,116072,634197,1041617,461006,614196,298545,285024,1017100,1009461,657405,207951,1012660,41184,926421,504052,709385,579346,493715,770783,498913,807626,585921,823945,563032,93482,767276,310097,979966,208679,338047,445349,1021310,602432,474754,197890,127483,580708,45542,734345,704514,268717,183401,913391,587843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]