SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802526 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802526 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1408,546252,34999,132669,212505,268540,54361,642135,1018861,41287,1042619,160423,73128,406963,942555,715910,519764,930917,830191,944601,361568,705435,541022,401071,710329,3930,280896,801978,903074,1013480,718675,9403,698095,486496,328549,902493,833282,305783,605445,973211,518539,302039,363245,538831,58327,701547,442724,962338,48656,302484,149730,847024,878607,337637,412771,177588,485603,297809,84805,448727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]