SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5180 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5180 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303559,716566,556010,687220,126643,66676,517964,271023,821835,141817,895976,727390,595662,296202,494813,940768,754655,48452,90872,118680,363063,557127,967033,397269,882784,506505,901661,44003,43087,146545,884913,171582,335819,262726,597920,136638,46492,192104,837578,839202,705925,605939,918426,843584,16072,209005,470433,825817,594378,128259,469569,895247,326823,710056,944419,561037,488447,108197,699958,271910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]