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` = 401893 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401893 [ RunTime:0.003020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519318,314990,338158,878132,549998,559288,355254,726729,803934,894793,88072,798809,813177,481266,666179,513083,485149,659532,2674,548192,1003952,61516,84835,754637,419117,777454,771822,734730,297333,318784,865009,1003540,244671,893474,455508,755170,431314,581225,616621,493111,801829,1034079,780303,142336,115327,641697,130165,476565,37288,965080,360787,938515,990298,78996,277550,662815,806503,253366,701542,987412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001696s ]