SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491955 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491955 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144249,410815,69761,284132,716546,952102,701083,605782,438197,502391,549760,815298,701059,717822,870514,350386,430466,858060,797983,786269,507056,828494,82322,343189,416524,978317,804128,745266,537332,115770,159103,121270,90208,155976,583822,122404,610565,463603,212305,342615,856686,419483,2064,522257,304026,358729,396952,252359,261587,582349,467487,520943,242087,451733,294760,1007066,208601,117809,898183,42680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491955 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491955 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002468s ]