SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531680 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531680 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311474,433879,615232,838412,802540,387570,594712,249600,727957,803310,846194,78037,98396,586723,167678,777560,606090,504249,761262,964168,591332,14422,917865,1035011,152825,865009,352483,1001173,795559,708482,970678,351049,490022,473203,895323,948036,662370,280747,807885,102992,1030999,69026,13589,140131,777124,269259,1042861,637382,634648,246436,524543,282373,40866,106782,9444,668363,80828,313484,298518,954764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]