SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447705 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447705 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417039,802175,512888,604722,2944,41288,470321,404043,820399,825782,120628,71402,533850,793088,371567,714394,983760,288213,1027804,162245,361874,858268,767684,163115,424793,756797,671716,459677,658405,564547,202600,275596,162981,879472,196738,349745,945040,151915,461477,244897,530976,281916,178323,1043302,547083,489836,993481,343281,399361,851843,233643,659408,1010095,503775,106262,86701,109193,139444,171914,38892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]