SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103080 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103080 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031270,316856,630542,256303,668117,927160,464625,349345,1030206,932844,724202,935038,811717,68079,45149,467908,287828,602740,653281,606542,347599,691357,844826,293768,325096,212854,323695,388522,850459,386066,539525,565430,853737,214102,249673,772933,990396,292615,369602,264195,998326,279175,474342,1028405,764854,760131,325169,695844,626963,161184,1025874,1037342,154265,834620,318283,974552,362109,600726,980297,557804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]