SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048873 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048873 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684771,378457,608288,1041360,268745,262039,707084,668812,250709,93101,126943,629527,794285,278648,101169,832038,731585,668773,1013464,984958,676031,821638,415643,1009345,917918,364779,991562,690429,294509,509782,118594,636699,734939,860432,257459,513129,1039394,208603,727867,261930,372366,142686,1042763,784842,209661,480052,594865,55685,595722,36671,260845,544998,437220,244120,726367,997981,986383,1012665,905701,201466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]