SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442534 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442534 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750073,35718,38861,611607,257255,318346,437246,402724,104860,651688,680851,160111,533728,353642,813954,65125,188751,860628,837205,397320,190269,874252,880808,40680,670476,728548,105296,334785,804585,136003,1007382,232574,386777,97364,65361,280267,794015,147420,771043,391274,838092,202279,454532,946237,321847,514316,429995,596669,673837,643305,181823,356531,464385,829890,578308,80375,219976,115788,466867,1008625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]