SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43762 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43762 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595916,627182,861665,249032,1048008,765665,322378,178971,808996,135304,34801,846309,942303,929156,780755,418094,537990,215513,397724,86661,480256,851230,640682,210021,255524,900209,250126,85421,563420,329671,208060,808926,25272,766864,879334,881322,149670,936004,905536,974396,113131,413074,41820,647728,533066,140877,705310,153642,991908,68509,910214,876037,522499,622397,347865,654488,1024734,435144,309109,973284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]