SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420420 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420420 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502206,1019600,580277,175761,918932,200818,731955,692026,815609,279724,861107,676782,519700,667516,672030,323170,1015332,299035,261004,41719,409800,412626,84769,40224,278467,34802,480955,334612,89805,1011461,761326,518152,870777,770360,256941,300578,77282,482715,529939,476240,27747,314346,527252,317379,295406,201691,1030005,100431,580378,432217,425541,637567,955992,186138,666414,789791,468372,625962,116031,813131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000964s ]