SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503580 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503580 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755729,114854,238028,134784,90175,585047,367554,978081,455484,948382,383302,507601,627515,984950,504274,825047,760964,895586,29016,688662,980873,572626,318651,988614,519663,360954,583856,347103,58890,85334,295234,749718,609529,985859,774604,1040858,754659,377352,107960,604411,93729,685854,74451,760042,264827,575862,844247,936551,351185,684496,926706,396981,281281,851110,996555,474234,545648,254534,974766,528221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]