SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467284 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467284 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022036,4444,625353,892405,822399,489263,575922,244676,232961,936391,1043668,410953,906482,722156,660551,384891,1012179,378492,805474,1043702,623413,834079,852316,506325,326562,210512,82859,378228,865594,174731,294481,179903,555612,943261,545533,336486,384923,613691,557591,915429,350927,455381,62868,757678,652490,626529,34987,140528,16990,497279,328111,104468,539435,878215,970194,598400,243091,241767,700668,759281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]