SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410741 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410741 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787274,522345,473191,804836,970572,680835,749083,611724,151288,233015,293808,170963,1033944,870590,295811,512948,412512,327806,1038909,466908,186700,1015058,250789,430722,789877,963221,778550,734284,312561,944519,950703,733042,830477,691785,903111,822101,958668,53120,60793,222936,499410,1047616,641514,259209,457713,613396,824042,18114,741501,517188,351825,671441,18907,782476,78383,110351,158933,571119,1036698,215721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]