SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396447 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396447 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027543,126521,476750,268767,552847,865389,413520,784207,638522,157958,609461,421584,69204,193992,618682,857124,1028656,568235,488013,314679,183775,530500,226072,773950,847255,118685,868044,654145,310241,860925,489901,557866,181702,1023051,965214,959094,106564,7709,53730,500516,729491,1019616,378136,542992,107067,271333,501736,598376,946943,386213,367643,914162,658860,456555,809454,464212,668803,509303,638702,852321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]