SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293197 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293197 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220208,1034295,693664,325610,158024,537640,13427,487059,437965,133469,358298,455814,254985,344160,500001,75398,512902,886710,840581,354212,467738,285277,747500,217048,346821,569647,126846,65101,786902,535801,383408,448799,288006,770233,948057,34363,674326,161636,1021859,136675,604034,284481,317442,736665,83199,29568,437980,533338,674271,523557,969266,1032268,485502,1008678,579184,718934,336667,344926,470626,490138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]