SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544271 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544271 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375532,431188,878387,83177,766618,364652,481493,205270,148675,155699,246029,363849,85768,445637,162796,40784,927049,283106,121033,994724,880492,929345,768572,710562,275100,497168,611721,1004610,587106,815356,513289,205877,935883,958234,407404,368441,632843,936415,148290,433383,1043933,785363,1026902,492095,1010478,536256,853938,154290,8141,897267,716123,197562,725118,6656,477649,842277,67801,667568,708087,145306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]