SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001926s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395844 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395844 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181978,681803,190910,399183,1029309,470873,291866,753053,774517,980394,794249,982000,203150,47880,81906,683246,551281,290280,970332,1040818,870369,55455,767724,231711,192473,1036627,431033,274742,215030,617213,442235,124346,441172,436169,726376,983040,199336,737782,678795,899013,297061,183746,934734,112486,185193,59324,1048291,406053,75439,490145,94155,781600,369984,349609,968874,389965,430904,21114,471996,542906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002541s ]