SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026344 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026344 [ RunTime:0.002878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349002,867518,304662,153112,527995,486156,677497,979107,845554,196848,1021510,117336,219003,41637,944179,912050,862823,7971,128967,812999,1039669,970954,685358,493592,607544,183444,1044762,290969,1043162,984925,748876,504588,465682,245506,130028,865337,983607,225956,498059,491523,7289,707767,887072,486543,411849,504334,19837,522518,1000361,30841,532153,111806,13871,566437,419075,871352,31638,922693,582546,163182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]