SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410352 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410352 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971650,744646,505566,744068,745771,399083,339799,565215,1034717,492025,528111,357336,981533,12541,378558,405165,542231,49583,154429,566314,832999,381493,967164,77022,816489,130853,625977,827083,1029637,318183,820419,730532,956866,587517,330508,351140,797232,210296,347519,664239,93985,637766,234945,398850,935871,353518,13343,184971,713157,522104,531838,189015,932693,898999,845865,1042599,894639,506148,514740,839728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]