SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002646s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41817 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41817 [ RunTime:0.004444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939141,860698,480688,938570,956591,64718,937864,541432,450785,142843,723006,871945,998030,867290,292413,944545,113100,694211,335029,844095,610735,743610,563840,813051,821678,886454,698655,665174,5651,620473,701522,343912,813286,547850,487223,627017,76009,823667,233460,975940,847673,585345,565421,727190,109332,377574,1007251,855805,146166,909910,497529,365723,407988,592973,121012,743655,209152,684164,684656,681064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001669s ]