SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501088 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501088 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714706,249998,938537,832352,601502,22955,425881,149995,505092,57483,185987,295383,85857,659067,73078,507894,729855,306074,393791,864563,289150,215309,514692,687764,861885,126548,239230,237545,794373,678191,1013018,725828,628488,1024672,1017719,89899,297421,782178,737127,659883,450933,918727,101122,906229,361720,883337,252293,229413,642428,866492,410642,1025917,654730,838649,30364,521039,47744,988915,10330,170503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]