SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587714 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587714 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307123,491956,326516,513431,387010,267016,81125,146115,1023339,740659,231212,446731,217131,380149,70641,966965,697150,1037541,867515,753122,681454,452775,163210,557223,940705,80239,129415,201143,516159,271887,2535,579405,617793,711148,916533,201130,916989,455118,227249,277379,571860,999526,611085,1037530,717631,1022186,404508,1040756,601647,467919,673708,998846,326146,140237,537768,934449,994057,712247,966991,194334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]