SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447060 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447060 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120799,879373,313522,1025436,837131,550587,329698,989648,164807,579377,67044,630897,596424,337754,183605,951919,1038029,31226,121344,597408,646675,461206,702069,714832,396835,1044669,994836,504549,147486,136683,402951,32883,627745,176644,1040187,267341,676927,448671,376830,604974,15521,511833,718124,48923,968685,384957,596447,449995,46578,1038125,181828,396381,920717,307311,252838,771005,124377,371160,910225,713723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]