SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483803 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483803 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534137,467078,505197,648159,930302,23793,278367,1037009,108461,514076,445369,782640,97130,324637,799897,878992,291919,628733,300723,403798,204805,976944,204299,71456,14301,369295,6875,123195,638194,290768,776566,801684,657392,468381,625075,274971,943981,277043,250722,576299,35232,1038115,628921,1009160,250120,492511,786632,681360,90353,953419,745226,505149,396363,158213,1034532,17882,698644,529773,392066,306810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001357s ]