SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043174 LIMIT 1 [ RunTime:0.001288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043174 [ RunTime:0.004017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158741,614054,386988,581484,876378,419868,25808,855840,1044382,69067,299018,377209,751331,569497,145184,985534,84386,681593,364800,812073,644678,567400,499592,1036609,635410,546694,508682,439981,698279,437765,35024,175840,190819,109247,668384,288851,304351,836319,574093,450471,536758,77783,244152,910606,327613,141782,207097,29677,107831,342592,135752,676942,370512,847576,657959,76889,341997,918247,798154,19876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043174 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043174 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001739s ]