SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403760 LIMIT 1 [ RunTime:0.000762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403760 [ RunTime:0.002363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504521,324112,646844,931679,334388,1841,212462,487315,205900,1000673,285997,833674,623323,324828,920659,848908,561504,29952,316942,42389,527504,915734,811008,150558,1048069,478140,221567,737640,796375,303086,517611,348838,507864,428728,311951,1026342,89948,928352,552903,52577,762685,390808,426607,578805,428820,609026,24252,883371,911478,430503,115274,603,277100,566706,742383,333621,730907,397032,629894,1044813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000836s ]