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` = 95741 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 95741 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455113,746546,1008223,1043893,572623,211941,229749,902776,327568,935107,579136,327640,735417,110510,770732,721061,683555,602073,873056,586242,781925,101198,332059,471673,506894,952961,1038567,85743,35374,631212,560449,10508,168302,96698,859893,91860,564267,853533,453052,734707,97813,587616,89203,301870,476396,387680,585478,686326,117328,827178,258868,615775,581733,350997,445519,1035156,200613,545850,885245,723175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 95741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 95741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]