SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401543 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401543 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547174,122008,934272,753601,362988,158748,786105,138948,73830,59124,229544,356028,266103,150861,127768,336741,385075,501873,1038086,376470,224833,341945,787113,415851,401567,690158,480787,239964,989000,194991,733123,153337,236165,732014,157565,319794,352636,721624,441117,757999,975875,441107,29278,757124,625217,640838,282618,309727,789380,117808,77365,976761,940987,111003,186656,671014,560003,230989,999181,828704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]