SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519487 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519487 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564752,205822,857947,962485,457148,1019716,761661,1026291,260278,414348,1031425,839481,873196,15102,360847,579527,14436,881922,171852,368147,273110,637951,868662,232445,959120,215648,505757,240108,832836,562068,45053,491654,198251,251152,726186,568370,329347,400373,432110,854546,323972,302946,247094,327346,776028,406568,511877,755444,785981,770819,460954,620077,951615,429717,219477,705879,739589,150515,845173,453822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]