SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283540 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283540 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584300,646330,261558,598314,894078,345740,761,371591,847327,429370,69079,420148,350569,43624,215464,156170,973083,107428,995863,397427,1037718,425553,747273,225092,229760,445486,507313,279352,696555,366982,844062,652394,565182,435267,706761,118882,871315,530181,114555,769756,237423,1005219,74350,23079,610143,963818,190199,721917,935390,485346,44767,3841,396307,688993,1030980,670976,520339,847809,946875,694358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]