SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580060 LIMIT 1 [ RunTime:0.001021s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580060 [ RunTime:0.002525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72042,596421,757576,471783,71233,224110,659674,144277,63948,740242,787409,945355,738866,715605,729491,254192,680662,35149,64657,364573,436162,386903,647126,792915,537815,764944,968919,643624,420491,426257,368860,414934,595650,722607,491766,105157,299718,351787,881717,980847,677519,759851,908394,400733,211783,159179,528063,590692,825986,1017164,533945,945811,823544,90333,679113,382760,407123,1032819,413779,337832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003103s ]