SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253083 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253083 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344618,9494,923455,713027,830616,453661,140064,186179,82675,824676,1048139,64989,349672,837656,1043368,1031560,222981,784615,620654,35485,879118,686132,343225,681875,506248,73132,449778,49815,588261,492476,352101,528191,734148,648930,106635,856980,862884,138659,601254,981583,159617,325367,506904,694364,411238,877634,515772,1010168,1009520,964796,354132,447363,1017030,597470,40362,705877,1005063,827271,669592,918521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]