SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480995 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480995 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478019,282580,699805,881050,938089,1019724,579571,45082,802343,23487,478256,41979,119381,1032033,291847,624040,43632,672974,173519,882489,998143,611139,227603,1044693,459383,1041637,514764,827153,650055,870009,975200,314520,553991,163117,601077,720952,28491,108413,470422,214925,696287,938146,541895,697665,850111,296305,344275,850224,498977,595900,649967,1035488,121257,98980,446152,774077,180245,40763,568332,907202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]