SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501425 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501425 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219080,998124,977685,401359,979616,3512,290355,1038315,445548,517529,713680,604258,80025,476557,570148,584744,175465,275918,925019,413330,571372,195974,460820,489166,1041646,492444,243122,596487,84085,661779,270551,506077,364983,587992,113980,137762,487331,414644,511538,813053,302551,578393,656468,396214,795676,428415,168391,943711,8697,131022,479987,265524,434937,237919,1044976,724288,335612,760712,132566,658270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002670s ]