SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031219 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031219 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003032,582404,1043138,258183,913667,473281,266634,307475,309697,112160,736944,34724,259784,549208,105786,798135,613541,540102,442225,180515,683344,913676,827999,165844,275007,361322,613682,89781,512475,315982,484726,22402,247157,873770,674202,126355,254002,768160,404747,265375,610683,597102,924459,121118,642717,722587,470446,959320,639099,151650,534162,772393,26222,471373,207477,471312,809754,580898,153391,104252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]