SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197411 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197411 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309103,269412,26924,110472,674519,130338,838224,829913,675359,406618,51206,587317,548239,316293,432710,466182,839792,942203,483254,400350,301542,795866,341915,615155,18834,294764,465733,865066,790172,1028880,207629,971270,519816,800109,719111,550449,331933,335264,1006396,847264,308790,344412,559553,805856,534592,961751,183545,347956,626204,299459,535078,1015856,41287,346787,909192,239058,397335,802066,874046,662933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]