SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111801 LIMIT 1 [ RunTime:0.000642s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111801 [ RunTime:0.004320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579901,783344,830611,904597,319696,891123,901804,1045418,973451,416766,1018058,189559,313123,622240,997819,341532,531339,193274,493354,694538,833814,778403,640375,997685,717914,218819,239245,953028,998987,115873,35865,482905,167848,826858,684844,879314,740792,262289,3654,149615,540764,289149,810281,657647,955850,302033,115502,234122,464792,17763,172359,702956,250803,353138,296450,806394,458900,707665,125362,419910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003863s ]