SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36482 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36482 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610920,840840,536467,576696,824113,957777,961545,840655,201904,305574,926733,26990,137391,769718,930018,224438,2707,378564,902411,406408,300097,455661,124080,10867,330078,1015333,826996,20549,237560,845962,912773,202972,1034493,53138,1002085,800183,262662,43925,434035,12358,105105,154001,857065,154583,110265,154069,745040,743760,648646,508907,170279,844492,870889,740543,1006517,396006,649660,774817,797887,164714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]