SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3912 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3912 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672877,250114,845546,938055,426093,524869,918438,405291,509026,514553,368083,203200,784396,1001530,674861,899094,312547,242866,891492,417599,93076,340853,633476,600536,491681,1021000,162463,942264,16417,251634,157498,883436,495047,558556,259945,271335,150046,672099,65747,537883,473579,789498,658104,3274,1023774,751756,9745,152395,262392,179828,341976,246424,815995,1043304,692113,88452,958865,705824,775,1020308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]