SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005048 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005048 [ RunTime:0.005516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789008,843814,909345,737428,836712,499580,948926,209373,541973,560038,1009644,788327,381265,248257,311323,732959,506146,352213,275894,583667,332050,9015,776671,615558,241017,585136,425219,7721,206138,1032057,675535,1017017,293161,1042943,560073,561849,411800,972151,288073,310231,883320,783000,159700,179597,491904,731344,55872,744741,1039545,383548,824239,1024700,633875,555974,772223,365585,722586,21361,165306,710969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]