SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247281 LIMIT 1 [ RunTime:0.002624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247281 [ RunTime:0.003201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273264,736997,457031,371650,802010,950702,292647,14541,604653,445748,41671,441100,157184,166285,51866,794270,76540,807234,502114,716925,904119,869932,171829,477221,755912,841333,660498,535187,73558,595559,931001,20117,749268,428448,792607,842491,431447,358361,995265,976754,1023277,229933,82989,808610,566460,731995,190093,736980,370685,780200,198649,457452,829176,63776,288663,770339,258119,353956,60983,482982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]