SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84411 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84411 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499616,15875,664952,7432,14439,133868,926884,355707,792180,604652,821504,139510,995328,190677,514922,886211,1031803,306123,283659,170756,94954,676929,153781,451843,190574,544485,582549,374332,890677,995896,18973,686298,544750,105231,317366,327200,803683,5100,722490,560742,939954,813369,487426,666020,16974,729465,201736,813736,718993,1043554,288885,451115,458839,340831,107718,655679,980520,819228,123552,928311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]