SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502179 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502179 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675273,780624,651009,1027435,709453,79273,1005923,1031037,54720,386280,809487,823013,232492,320135,833320,134593,1007465,958523,1039849,119544,411907,1017965,1007529,49721,467320,777292,818842,492649,14912,62549,269998,734823,639107,763763,713962,3563,385407,678780,599076,604076,514023,515637,119478,291900,734497,961083,143536,808324,530909,251902,921388,678970,1023272,845626,227950,1025912,303975,662187,930340,247358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]