SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467915 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467915 [ RunTime:0.002369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837537,1044468,1011638,32993,862491,8531,228967,504044,854366,219814,687466,814405,705335,590717,143409,297915,606370,498392,868711,3079,302559,934835,706928,346798,453384,86556,1019888,296611,47134,89614,899750,339478,1039237,591831,860133,674065,692591,35988,815787,690480,660347,553015,222875,343403,967998,233896,92798,451123,614777,298864,202025,430192,269053,490284,201236,154563,431223,395926,507524,27534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]