SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567081 LIMIT 1 [ RunTime:0.001451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567081 [ RunTime:0.003238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670918,627171,773299,848714,265914,119144,528833,40961,921796,562434,390547,513110,253586,434012,303595,85470,524317,180688,692201,801522,847165,915731,372795,415574,585499,624297,851058,77421,709424,1038477,69968,107901,693359,371125,1012690,539173,735622,1009595,543247,149745,571865,395,319584,616641,516886,499183,427608,699911,884134,750046,40916,838541,99108,241324,538775,252825,700655,298540,774385,601001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000863s ]