SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645604 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645604 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474318,516506,1020106,66180,195907,489564,284331,884087,449217,432977,165526,235140,476589,391375,896677,1040083,246260,1010655,928753,334110,656729,513520,103171,856402,87208,754334,921089,601336,200058,108074,881952,837513,352102,1048741,801612,197959,116981,311105,841581,397527,480676,588359,14010,851255,1028539,522021,399011,474820,866364,731173,130561,518522,708162,967584,944198,99833,124174,514367,1019830,187893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]