SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477978 LIMIT 1 [ RunTime:0.002746s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477978 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617201,322563,829822,274825,1024253,578977,392582,475445,432935,503713,633204,45159,850636,712225,533685,440646,525763,924341,548480,946199,148814,859064,437869,276175,668377,123133,83882,1042378,599551,915560,796683,946255,788884,89983,434805,133237,242013,873326,402345,424374,357706,726278,258199,749034,306691,8699,910869,896670,242416,783169,267247,909355,251038,115396,399196,110981,609806,651709,621158,957257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005738s ]