SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484104 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484104 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404447,151536,177606,988776,414605,652809,992600,232174,621611,1048106,931018,199607,325975,665869,423165,902850,131455,898348,845342,234478,44718,5532,178995,21292,893200,130661,345981,806410,200259,506833,376947,27453,980091,595507,717299,865051,715069,369223,579612,442530,329737,346112,536357,619285,898289,452321,1014200,750879,900501,76731,620384,532487,241315,306908,460960,831620,335986,213717,934285,591471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]