SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583940 LIMIT 1 [ RunTime:0.000731s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583940 [ RunTime:0.003309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010222,730547,392779,722091,1040282,204775,514261,822880,599004,994443,145925,779198,377918,700141,392889,134036,76215,754060,1034433,310621,15360,803597,148665,479987,988629,657064,855799,589670,255391,812260,393310,1043164,632741,856918,32549,58877,355666,809772,725152,165452,330611,383943,505660,108194,110049,939292,668008,735869,242147,738578,449353,523235,834715,344659,345779,393889,442328,978516,601465,1010390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]