SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310495 LIMIT 1 [ RunTime:0.001572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310495 [ RunTime:0.003493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405659,939508,714953,810212,1024390,1040315,631331,509394,77771,1032881,163908,62222,249241,461309,219958,871462,27986,564196,487847,686602,451137,37093,298784,770969,455261,534975,183828,343951,1037557,547144,592149,597631,23973,324775,331975,78234,860206,1040759,182214,553646,317344,147361,695848,356782,179088,788513,46365,509115,359522,594085,556589,870553,652632,851266,947150,903931,472555,292358,471735,234665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]