SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314996 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314996 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573709,310195,714033,1011681,442734,337858,437406,603299,34218,934701,548821,402315,373858,510710,801322,1047066,166281,320124,750314,719115,529975,191099,389467,967265,141035,547802,877149,1025034,147497,840039,708035,880968,252891,400945,638947,532513,283419,471352,792210,736371,534037,916247,88590,980063,89903,13960,424745,628317,1027968,7263,1045671,56049,1008710,745129,416372,556783,557295,34500,755083,412987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]