SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322580 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322580 [ RunTime:0.002468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730074,1011133,140832,102858,669013,981673,390296,674426,672373,496176,669084,922361,731707,782064,10371,254887,377019,91520,988931,889012,579124,798872,30506,735400,415790,355740,806426,163834,334759,482811,453107,859155,275564,761931,509086,845013,384070,545745,561761,214729,672776,891979,811500,371962,417078,419435,279478,804185,678439,319710,546484,636328,43642,244991,379095,775980,559105,118625,9547,118232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]