SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556522 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556522 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497959,296228,60426,141147,571574,425670,420819,850335,383911,844414,2210,821492,278077,810919,947044,312336,84900,815806,20673,295476,45496,217758,923085,433272,601086,313209,232183,610037,801147,719225,519229,448537,577207,189049,233704,385686,425197,105385,795197,78349,858309,540059,138161,728107,590554,991502,447483,670747,448693,734297,77114,291828,367865,678163,878088,1048715,252121,841538,864281,1002726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]