SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408053 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408053 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576437,623147,578445,329262,205271,293151,676500,959801,797331,497571,1031764,617505,116974,1048772,615351,781865,188117,133189,589961,100170,868787,494492,676728,802830,939345,841655,99217,930101,824794,53291,151279,1016018,25932,619669,988960,16083,989700,474204,1047935,760875,702533,226234,606089,540272,427224,208351,781044,36519,946018,616652,520004,589756,1015240,831805,552828,159047,760698,800222,732454,240149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]