SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031689 LIMIT 1 [ RunTime:0.001961s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031689 [ RunTime:0.005587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452517,22853,289201,114227,511594,981102,337446,44414,1017182,884387,575131,581810,213972,817425,805323,635620,1019787,608922,271919,78460,62971,892995,200981,334014,530865,360453,190630,693206,129217,367614,195132,282792,935129,374565,494296,968165,551682,618702,326068,1025743,1002635,555556,331481,230344,581245,35243,662655,250031,790909,46113,624595,917238,193556,387401,29446,839114,686617,321448,931596,624794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]