SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411094 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411094 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527361,561788,125758,632489,838022,214817,708109,688676,177471,113959,95908,872273,789746,365641,302814,932166,704618,513063,158459,420098,120443,705548,159094,1012318,899789,247217,958876,663909,15515,640445,378990,401439,854886,350690,728337,255929,426852,1042910,877743,941263,185241,874088,653544,1047298,489718,534031,720578,715282,46674,401510,548397,513859,330748,819704,352089,333936,72800,20081,201923,397609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]