SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474100 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474100 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102146,214971,177689,685943,872802,609640,109254,452142,1030398,376477,978885,895703,560248,140711,767615,470149,86877,845998,664762,310939,255866,683842,1008276,611692,248365,149027,625851,16138,1000227,472768,171292,781944,225783,1022710,274015,519352,1027668,682850,258824,285688,333516,1037415,218344,789735,398060,258088,10105,702881,448623,836817,1010738,262475,987231,297636,995172,602910,669874,503794,614011,43565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]