SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549182 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549182 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744421,872142,1006397,623875,163408,379276,25595,361293,709257,829323,1704,743924,971779,126021,286257,966556,607624,989829,266107,557380,891316,41617,836139,98979,750010,777960,319730,1017037,95263,820927,992603,740273,914869,80096,467692,260903,834184,1017040,42419,548635,424771,607695,294497,110291,774213,1048205,507853,143945,937825,914369,318214,917848,642933,469289,151684,450899,807622,759337,488894,278119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]