SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102362 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102362 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815584,729831,758063,394159,368949,110999,837177,367836,1011118,816474,129278,405399,1011801,754077,126090,588877,469362,617312,367325,6866,297405,47949,608652,444562,547325,454545,541998,1038127,885388,587571,204838,33751,707200,192437,1003437,610176,504035,165997,448711,463815,842847,707227,503102,180513,976694,43382,711391,707473,828973,1000896,559174,838991,260127,149883,101766,104905,694743,808870,21727,874197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001047s ]