SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002975s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381035 LIMIT 1 [ RunTime:0.001787s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381035 [ RunTime:0.003585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002362,592625,490013,431318,443080,630687,815687,800133,36875,725573,573835,704205,953872,15710,976409,775594,273169,144315,243629,816712,109916,109081,580978,233873,399474,1026663,998225,945128,526222,882582,98770,800229,835688,476287,339131,748674,1019184,107239,963682,925924,695385,503928,1029101,145191,734411,312673,1005714,473227,880259,962439,925518,279956,677058,833273,90373,415034,313687,306521,369577,384524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]