SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550596 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550596 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445471,24553,1039963,807322,355154,303894,395878,851590,371012,745373,387667,771497,142414,820020,260775,864911,605286,137697,944241,389908,400558,777895,556078,264072,291571,1030056,725296,1035601,913361,376454,1008720,655973,70479,169860,414851,160027,67228,417345,252257,83686,541005,207975,639005,1007601,378783,446362,67162,627379,618813,632651,994542,297733,609196,470347,537598,426254,261822,130625,573390,586686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]