SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400818 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400818 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165076,667489,809351,204972,205555,193674,387692,279780,514276,886357,4515,198288,282564,843578,63303,177286,189255,260848,331705,20510,109866,594155,682315,780726,265645,470342,649448,230128,745527,162726,1018426,1006735,351411,672819,683435,4988,730412,838453,439935,706205,441991,993719,105836,155656,650567,1001031,599767,4283,763107,648074,793081,874017,887675,107529,226063,346542,410103,56213,819623,712907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]