SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041145 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041145 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005034,126573,673336,237991,547865,661126,695394,353503,73210,1034038,277252,871539,438930,642523,387462,843250,597384,796163,103199,463022,531327,475436,949104,553914,892498,485203,217831,459271,47084,655500,693090,438810,219542,449321,162514,6620,874554,719999,106690,445002,35592,862561,274960,133548,273430,769628,1017970,362264,269144,865519,751488,492649,825235,744972,450224,303993,383177,223690,597494,976422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]