SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022741 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022741 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431264,429227,133100,913752,521645,433022,401518,28286,495965,436551,589388,670030,700503,373578,2467,122546,375599,315774,158101,781438,717776,475726,520980,389145,450890,68938,566521,496280,274021,358326,477417,693431,875497,164005,310627,181948,111952,391341,1009123,754830,199294,759802,962002,593758,1021957,136404,527005,579782,154672,50918,201410,774450,106187,71281,956900,201599,187506,302074,513599,536582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]