SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901743 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901743 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715435,461272,745242,710066,764743,109340,841380,1003262,139803,745604,751774,751841,274535,239472,801544,780085,1365,501757,999741,139198,11815,661454,988536,887369,774580,796659,741606,937151,487215,549793,103868,456995,689963,960156,338247,392439,535456,483428,657182,191101,821404,976169,757557,1006979,571146,975779,534338,190382,185705,340359,132486,619266,474245,461318,1010824,205650,367901,442650,320080,490930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]