SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547207 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547207 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273673,956233,372779,843000,1031132,907118,353817,4481,10582,255175,376342,744834,1022141,178395,285107,42060,73317,825841,838417,5993,960212,971691,298899,366815,96084,1015710,435170,432173,993435,713704,225840,564270,380950,277829,314016,723987,664941,168709,455602,506049,908316,96787,1039649,880684,493441,276316,65967,542302,28887,965358,463092,705555,540358,444330,380168,110494,22540,805645,897903,845351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001277s ]