SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122913 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122913 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480314,261544,95960,742591,607467,875488,652039,892551,164258,778669,122989,399097,119067,27878,838280,400610,886775,878323,103270,79876,557192,556224,244978,916357,91147,200530,470849,965162,281262,446805,271975,900471,423150,197496,289374,390896,953546,963076,460820,483993,314060,96124,9406,195161,140227,277592,942567,161845,537705,578706,468021,489433,403281,784081,28235,857497,167077,274596,753694,252732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]