SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405193 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405193 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544691,679946,38417,591157,634707,561021,463066,427832,979967,273334,1029619,894062,103586,585321,9715,63032,441872,478779,399433,688451,990881,807289,219005,740864,13733,503465,416013,878634,340495,183092,966560,396373,841982,752170,436746,1033536,13692,627835,408165,333458,415848,875753,993809,327969,282710,81902,973977,401922,232139,273176,407775,1038478,678277,159202,990473,1029243,150468,494719,515513,1021691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002211s ]