SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981711 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981711 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356500,761728,842836,695892,217088,399862,201937,837336,777650,402272,744822,684356,244971,362226,249646,267669,973089,60047,56105,352556,580241,785809,912616,240226,750918,594505,670196,1009898,183028,697187,1000808,592634,641232,950914,318922,725398,139832,514521,620314,683752,80006,61811,39378,592014,130125,49649,311743,194923,1019037,906321,267926,908708,948589,868551,604228,986559,809265,436772,412323,1017763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]