SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305550 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305550 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784249,256358,591556,550001,700455,4305,608914,896240,886068,878833,864299,768556,21078,156204,1047499,331948,480390,1027004,1047898,904626,277427,808045,979000,750712,402992,304635,358080,106598,708166,1015240,55934,648619,905523,399317,875888,168305,203296,991998,699345,361274,530068,804961,538195,364152,867958,476956,464733,265758,123089,318464,325869,937326,670983,178189,618978,415519,970772,55415,899378,482109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]