SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 979920 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 979920 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509776,760882,968805,676569,199075,185124,401536,816585,483623,586381,976843,410805,511060,970392,968513,159282,156724,936096,420942,66485,193897,408656,532565,833023,619228,495244,217943,847667,685128,890280,520161,994632,355978,738604,75366,880307,325393,52447,688844,241459,516919,614678,321942,314272,376652,311781,421706,897709,10728,1010997,764072,975176,931461,644672,495877,291837,529609,882047,428029,514620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 979920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 979920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]